R语言数据导出和导入 csv tsv xls xlsx

还没想好123

已于 2023-01-16 21:24:16 修改

阅读量1.5w

点赞数 8

文章标签： r语言

于 2021-12-04 21:10:33 首次发布

本文链接：https://blog.csdn.net/weixin_46623488/article/details/121721861

版权

【R语言】Excel

导出为Excel的xls、xlsx

#【-------导出数据--------】
write.table(data2, file ="train1.xls", sep="\t", row.names =TRUE, 
            col.names =TRUE, quote =TRUE)

write.table(data2, file ="train2.xlsx", sep="\t", row.names =TRUE, 
            col.names =TRUE, quote =TRUE)

write.table(data2,"train3.txt",  sep="\t",  row.names=TRUE,
             col.names=TRUE, quote=TRUE,)

# 【xls、xlsx】导出需要可以把行名换出来到列,不然上面导出来第一个空格被占
data3=cbind(id=row.names(data), data)
write.table(data3, file ="train4.xlsx", sep="\t",
            col.names =TRUE, quote =TRUE)


#【--------导入数据------------】
data <- read_excel("C:/XXX/1.xlsx", sheet = "Sheet1", col_names = TRUE)
data <- read.table(file = 'manifest.tsv', sep = '\t', header = TRUE) 
data <- read.csv('microOTUtable.csv')